<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
    <xsl:output method="xml" encoding="UTF-8"/>
    <xsl:template match="/">
        <xsl:processing-instruction name="mso-application">
            progid="Excel.Sheet"</xsl:processing-instruction>
        <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
            xmlns:o="urn:schemas-microsoft-com:office:office"
            xmlns:x="urn:schemas-microsoft-com:office:excel"
            xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
            xmlns:html="http://www.w3.org/TR/REC-html40">
            <Styles>
                <Style ss:ID="Default" ss:Name="Normal">
                    <Alignment ss:Vertical="Bottom"/>
                    <Borders/>
                    <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Size="9"
                        ss:Color="#000000"/>
                    <Interior/>
                    <NumberFormat/>
                    <Protection/>
                </Style>
                <Style ss:ID="s1">
                    <Borders>
                        <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                        <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                        <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                        <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
                    </Borders>
                    <Interior ss:Color="#BFBFBF" ss:Pattern="Solid"/>
                </Style>
                <Style ss:ID="s2">
                    <Borders>
                        <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
                        <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
                        <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
                        <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
                    </Borders>
                </Style>
            </Styles>

            <Worksheet ss:Name="Данные">
                <Names>
                    <NamedRange ss:Name="_FilterDatabase" ss:Hidden="1"
                        ss:RefersTo="{concat('=Данные!R1C1:R1C',count(Table/Row[1]/Cell))}"
                    > </NamedRange>
                </Names>
                <Table ss:ExpandedColumnCount="{count(Table/Row[1]/Cell)}"
                    ss:ExpandedRowCount="{count(Table/Row)}" x:FullColumns="1" x:FullRows="1"
                    ss:DefaultRowHeight="15" ss:DefaultColumnWidth="100">
                    <xsl:for-each select="Table/Column">
                        <Column ss:AutoFitWidth="0" ss:Width="{@width}"/>
                    </xsl:for-each>
                    <xsl:for-each select="Table/Row">
                        <xsl:variable name="row" select="position()"/>
                        <Row ss:AutoFitHeight="0">
                            <xsl:for-each select="Cell">
                                <xsl:choose>
                                    <xsl:when test="$row=1">
                                        <Cell ss:StyleID="s1">
                                            <Data ss:Type="{@type}">
                                                <xsl:value-of select="text()"/>
                                            </Data>
                                            <NamedCell ss:Name="_FilterDatabase"/>
                                        </Cell>
                                    </xsl:when>
                                    <xsl:otherwise>
                                        <Cell ss:StyleID="s2">
                                            <xsl:if test="not(text()='')">
                                                <Data ss:Type="{@type}">
                                                  <xsl:value-of select="text()"/>
                                                </Data>
                                            </xsl:if>
                                        </Cell>
                                    </xsl:otherwise>
                                </xsl:choose>

                            </xsl:for-each>
                        </Row>
                    </xsl:for-each>

                </Table>
                <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
                    <PageSetup>
                        <Header x:Margin="0.3"/>
                        <Footer x:Margin="0.3"/>
                        <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
                    </PageSetup>
                    <Unsynced/>
                    <Selected/>
                    <ProtectObjects>False</ProtectObjects>
                    <ProtectScenarios>False</ProtectScenarios>
                </WorksheetOptions>
                <AutoFilter x:Range="{concat('R1C1:R1C',count(Table/Row[1]/Cell))}"
                    xmlns="urn:schemas-microsoft-com:office:excel"> </AutoFilter>
            </Worksheet>
        </Workbook>
    </xsl:template>
</xsl:stylesheet>
